Changes in This Release for Oracle Big Data SQL

A significant change in Oracle Big Data SQL 3.0 is the expansion of support to non-Oracle servers in addition to support for Oracle Big Data Appliance/Oracle Exadata Database Machine installations. Another new feature to note is predicate push down.

Predicate Push Down

Big Data SQL 3.0 takes advantage of predicate off-loading support by pushing SARGable (Search ARGument ABLE) predicates from Oracle Database into supporting systems. See About Predicate Push Down

Support for Servers Other than Oracle Engineered Systems

Prior to Release 3.0, Oracle Big Data SQL supported only Oracle Engineered Systems. Specifically, Oracle Big Data Appliance (on the Hadoop side), and Oracle Exadata Database Machine (on the database server side). As of Release 3.0, Oracle Big Data SQL also runs on the Hortonworks Hadoop Data Platform and on Cloudera’s Distribution Including Apache Hadoop (CDH) systems other than Oracle Big Data Appliance.

Big Data SQL also now supports Oracle Database running on servers other than Oracle Exadata Database Machine.

See the Oracle Big Data SQL Master Compatibility Matrix (Doc ID 2119369.1) in My Oracle Support for supported operating systems, Hadoop distributions, and Oracle database configurations.

Note:

Oracle Big Data SQL does not yet support connections between Oracle Engineered Systems and other servers. The following configurations are not supported in Release 3.0.
  • Oracle Exadata Database Machines connected to a Hadoop system other than Oracle Big Data Appliance.

  • Non-Exadata Oracle Database servers connected to Oracle Big Data Appliance.

The Oracle Database server used in conjunction with either the HDP or CDH Hadoop systems described above must be a non-Exadata machine.